Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# NLS_CALENDAR

Property | Description
--- | ---
Parameter type | String
Syntax | `NLS_CALENDAR = "``calendar_system``"`
Default value | None
Modifiable | `ALTER SESSION`
Range of values | Any valid calendar format name
Basic | No

`NLS_CALENDAR` specifies which calendar system Oracle uses. It can have one of the following values:

- Arabic Hijrah

- English Hijrah

- Gregorian

- Japanese Imperial

- Persian

- ROC Official (Republic of China)

- Thai Buddha

For example, suppose `NLS_CALENDAR` is set to "Japanese Imperial", the date format is "E YY-MM-DD". ("E" is the date format element for the abbreviated era name.) If the date is May 15, 1997, then the `SYSDATE` is displayed as follows:

    SELECT SYSDATE FROM DUAL;
    SYSDATE
    --------
    H 09-05-15

See Also: Oracle Database Globalization Support Guide for a listing of available calendar systems